﻿/*****************************************************************************/
/* Step 2. Create stored procedure                                           */
/*****************************************************************************/
CREATE PROCEDURE [Kernel].[PersonWith]( @PersonOID BIGINT )
AS 
BEGIN

	SELECT OID, 
	Version, 
	FirstName, 
	LastName, 
	MiddleInitial, 
	DOB, 
	Sex, 
	Phone1, 
	Phone2, 
	eMailAddress 
	From People
	Where OID = @PersonOID

END


